# -*- coding: utf-8 -*-
##############################################################################
#
#    OpenERP, Open Source Management Solution
#    Copyright (C) 2013 Fxiao (<http://xiao.iteye.com>).
#
#    This program is free software: you can redistribute it and/or modify
#    it under the terms of the GNU Affero General Public License as
#    published by the Free Software Foundation, either version 3 of the
#    License, or (at your option) any later version.
#
#    This program is distributed in the hope that it will be useful,
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#    GNU Affero General Public License for more details.
#
#    You should have received a copy of the GNU Affero General Public License
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
##############################################################################

from openerp.osv import fields, osv

class res_partner(osv.osv):
    _name = 'res.partner'
    _inherit = 'res.partner'

    def _check_number(self, cr, uid, ids, context=None):
        obj = self.browse(cr, uid, ids[0], context=context)

        fields = []
        if obj.phone:
            fields.append("phone='%s'" % obj.phone)
            fields.append("mobile='%s'" % obj.phone)

        if obj.mobile:
            fields.append("phone='%s'" % obj.mobile)
            fields.append("mobile='%s'" % obj.mobile)

        if not fields:
            return True

        sql = """SELECT COUNT(*) FROM res_partner WHERE %s""" % " OR ".join(fields)
        cr.execute(sql)

        if cr.fetchone()[0] > 1:
            return False

        return True

    _constraints=[
        (_check_number, u'该手机号或电话是已存在!', ['phone', 'mobile'],),
    ]


# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
